CREATE TABLE [dbo].[Publish_Request]
(
[PublishRequestID] [int] NOT NULL IDENTITY(1, 1),
[ContactID] [numeric] (18, 0) NOT NULL,
[NavMenuID] [numeric] (18, 0) NULL,
[RequestDateTime] [datetime] NOT NULL,
[PublishedDateTime] [datetime] NULL,
[PublishPriorityCode] [smallint] NOT NULL CONSTRAINT [DF_Publish_Request_PublishPriorityCode] DEFAULT ((5))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Publish_Request] ADD CONSTRAINT [PK_Publish_Request] PRIMARY KEY CLUSTERED ([PublishRequestID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Request_NavMenuID] ON [dbo].[Publish_Request] ([NavMenuID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Request_PublishPriorityCode] ON [dbo].[Publish_Request] ([PublishPriorityCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Publish_Request] ADD CONSTRAINT [FK_Publish_Request_Nav_Menu] FOREIGN KEY ([NavMenuID]) REFERENCES [dbo].[Nav_Menu] ([NavMenuID])
GO
ALTER TABLE [dbo].[Publish_Request] ADD CONSTRAINT [FK_Publish_Request_Publish_Priority] FOREIGN KEY ([PublishPriorityCode]) REFERENCES [dbo].[Publish_Priority_Ref] ([PublishPriorityCode])
GO
GRANT REFERENCES ON  [dbo].[Publish_Request] TO [IMIS]
GRANT SELECT ON  [dbo].[Publish_Request] TO [IMIS]
GRANT INSERT ON  [dbo].[Publish_Request] TO [IMIS]
GRANT DELETE ON  [dbo].[Publish_Request] TO [IMIS]
GRANT UPDATE ON  [dbo].[Publish_Request] TO [IMIS]
GO